Notice (8): Undefined index: listdesc [APP/models/department.php, line 45]
Notice (8): Undefined index: is_exclusive [APP/controllers/allproperties_controller.php, line 4403]
Warning (2): array_key_exists() expects parameter 2 to be array, boolean given [APP/models/allproperty.php, line 788]
Notice (8): Undefined offset: 0 [APP/models/allproperty.php, line 794]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 351]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 456]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 462]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 469]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 470]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 474]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 479]
Notice (8): Undefined index: is_exclusive [APP/models/allproperty.php, line 483]
Jean Louis VERGÉ's selection of French property for sale
My properties red circle favorite
Notice (8): Undefined variable: countFav [APP/views/elements/new/header-desktop-top-menu.ctp, line 67]
avatar support
9-18h - Mon. to Sat. +33 (0)5 53 60 84 88 International
avatar support
click for phone number
9-18h - Mon. to Sat.
+33 (0)5 53 60 84 88
My properties red circle favorite
Notice (8): Undefined variable: countFav [APP/views/elements/new/header-desktop-top-menu.ctp, line 168]
Search icon close icon navigation
Notice (8): Undefined index: sort [APP/views/allproperties/agent.ctp, line 4]
Notice (8): Undefined index: direction [APP/views/allproperties/agent.ctp, line 4]

Selection of French properties for sale by Jean Louis VERGÉ

Selection
of French properties for sale
by Jean Louis VERGÉ

Independent Sales Agent
SIREN: 850807942

agent photo - jean louis  vergÉ
agent photo - jean louis  vergÉ

Jean Louis VERGÉ
Independent Sales Agent
SIREN: 850807942
Regions
Midi-Pyrénées (Occitanie)

About me

I worked as a construction foreman for more than 25 years, then I moved on to become a real estate consultant, which is a real passion. On a personal basis, I have bought several houses with renovation works that allowed me to acquire good knowledge and especially the value of properties with their potential. I live with my wife, a dog and a cat in the Haute Garonne. It is through the plains, valleys, hills that I am looking forward to meeting you, guiding you, helping you to find the house of... read more

About my area

We live near Toulouse "La ville ROSE", near the Pyrenees, it is a region that we love and that we have always known, as soon as possible, we take the paths, for simple walks or hikes with remarkable landscapes, an intoxicating patchwork of colors, a discovery of Nature very rich, a Region full of History, Tradition, Gastronomy. The Midi Pyrénées region is full of wonders where life is... read more
I worked as a construction foreman for more than 25 years, then I moved on to become a real estate consultant, which is a real passion. On a personal basis, I have bought several houses with renovation works that allowed me to acquire good knowledge and especially the value of properties with their potential. I live with my wife, a dog and a cat in the Haute Garonne. It is through the plains, valleys, hills that I am looking forward to meeting you, guiding you, helping you to find the house of your dreams in the south-west of France. close
We live near Toulouse "La ville ROSE", near the Pyrenees, it is a region that we love and that we have always known, as soon as possible, we take the paths, for simple walks or hikes with remarkable landscapes, an intoxicating patchwork of colors, a discovery of Nature very rich, a Region full of History, Tradition, Gastronomy. The Midi Pyrénées region is full of wonders where life is good. close
Warning (2): array_key_exists() expects parameter 2 to be array, string given [APP/models/allproperty.php, line 788]
Warning (512): SQL Error: 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'frenchestateagents.Allproperty.postcode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [CORE/cake/libs/model/datasources/dbo_source.php, line 526]

Query: SELECT `Allproperty`.`properpubtown`, `Allproperty`.`postcode`, count(*) as count FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `user_id` = 14312 AND `Allproperty`.`isinvisible` != 1 GROUP BY properpubtown ORDER BY `properpubtown` ASC, `postcode` ASC

Warning (2): Invalid argument supplied for foreach() [APP/models/allproperty.php, line 350]
Warning (2): Invalid argument supplied for foreach() [APP/models/allproperty.php, line 513]
6 properties

page 1 / 1 - sort by :

Approximate location icon close map

icon top scroll
(default) 15 queries took 410 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `primarypropertytypes`338
2DESCRIBE `groups`446
3DESCRIBE `proptypes`774
4DESCRIBE `groups_proptypes`3346
5SELECT `User`.`id`, `User`.`role`, `User`.`name`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`primary_email`, `User`.`created`, `User`.`modified`, `User`.`team_id`, `User`.`statute`, `User`.`persinfo`, `User`.`persinfo_fr`, `User`.`locinfo`, `User`.`locinfo_fr`, `User`.`location`, `User`.`areas`, `User`.`isdeleted`, `User`.`active`, `User`.`statute_fr`, `User`.`address1`, `User`.`commune`, `User`.`postcode`, `User`.`initials`, `User`.`depts`, `User`.`cp`, `User`.`kbis`, `User`.`siret`, `User`.`trusted`, `User`.`allowed_area`, `User`.`lat`, `User`.`lon`, `User`.`notgeo`, `User`.`picture`, `User`.`hestia_id`, `User`.`phone_number`, `User`.`request_contact_details_fr`, `User`.`request_contact_details_en` FROM `users` AS `User` WHERE `User`.`id` = 14312 LIMIT 1114
6SELECT `Department`.`id`, `Department`.`listcode`, `Department`.`listdesc`, `Department`.`region_id`, `Department`.`dbfield`, `Department`.`text`, `DepartmentsUser`.`id`, `DepartmentsUser`.`user_id`, `DepartmentsUser`.`department_id` FROM `departments` AS `Department` JOIN `departments_users` AS `DepartmentsUser` ON (`DepartmentsUser`.`user_id` = 14312 AND `DepartmentsUser`.`department_id` = `Department`.`id`) 006
7SELECT `Codepostal`.`id`, `Codepostal`.`name`, `Codepostal`.`postcode`, `Codepostal`.`department_id` FROM `codepostals` AS `Codepostal` WHERE `Codepostal`.`postcode` = 31600 LIMIT 1118
8SELECT `Department`.`id`, `Department`.`listdesc`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`id` = '31' LIMIT 1112
9SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '73' LIMIT 1116
10SELECT COUNT(*) AS `count` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `Allproperty`.`user_id` IN (14312, 15026) AND `Allproperty`.`isinvisible` != 1 1137
11SELECT `Allproperty`.`id`, `Allproperty`.`propref`, `Allproperty`.`primarypropertytype_name`, `Allproperty`.`pubtown`, `Allproperty`.`properpubtown`, `Department`.`listdesc`, `Region`.`name`, `Allproperty`.`image_0`, `Allproperty`.`status`, `Allproperty`.`isunderoffer`, `Allproperty`.`is_exclusive`, `Allproperty`.`date_made_live`, `Allproperty`.`nrbedrooms`, `Allproperty`.`nrbathrooms`, `Allproperty`.`habitable_m2`, `Allproperty`.`land_m2`, `Allproperty`.`issold`, `Allproperty`.`poa`, `Allproperty`.`bestdeals`, `Allproperty`.`price`, `Allproperty`.`prevprice`, `Allproperty`.`propname`, `Allproperty`.`shortdesc`, `Allproperty`.`floorplan`, `Allproperty`.`tour`, `Allproperty`.`youtube_url`, `Allproperty`.`rhinov_url`, `Allproperty`.`region_id`, `Allproperty`.`lat`, `Allproperty`.`lon`, `Allproperty`.`postcode`, `Allproperty`.`attributes`, `Allproperty`.`mandatetype_id`, `Allproperty`.`department_name`, `Allproperty`.`department_id`, `Allproperty`.`created` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `Allproperty`.`user_id` IN (14312, 15026) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`price` DESC, `Allproperty`.`id` DESC LIMIT 4866245
12SELECT COUNT(*) AS `count` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE ((`Allproperty`.`user_id` IN (14312, 15026)) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1131
13SELECT `Allproperty`.`properpubtown`, `Allproperty`.`postcode`, count(*) as count FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `user_id` = 14312 AND `Allproperty`.`isinvisible` != 1 GROUP BY properpubtown ORDER BY `properpubtown` ASC, `postcode` ASC 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'frenchestateagents.Allproperty.postcode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by3
14SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13132
15SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13132
(legitnew) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)